"192.168.0.1:sipop" Previous topic Chapter index Next topic

PAIS

 

 

Descriptions

PAIS REGISTRADO EN EL SISTEMA

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

ID_PAIS

 

CHAR (3)

 

ID del pais

 

 

NOMBREPAIS

 

CHAR (30)

 

Nombre del pais

 

Triggers

There are no triggers for table PAIS

 

Indices

There are no indices for table PAIS

 

References

There are no references for table PAIS

 

Referenced

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

DEPARTAMENTO

INTEG_248

ID_PAIS

ID_PAIS

RESTRICT

RESTRICT

PROVEEDOR

INTEG_281

PAIS

ID_PAIS

RESTRICT

RESTRICT

 

Definition


CREATE TABLE PAIS (
    ID_PAIS CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBREPAIS CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE PAIS ADD PRIMARY KEY (ID_PAIS);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic